|
1
|
|
|
/** global: Analytics */ |
|
2
|
|
|
/** global: google */ |
|
3
|
|
|
/** |
|
4
|
|
|
* Utils |
|
5
|
|
|
*/ |
|
6
|
|
|
Analytics.Utils = { |
|
7
|
|
|
responseToDataTable: function(response, localeDefinition) { |
|
8
|
|
|
var dataTable = new google.visualization.DataTable(); |
|
9
|
|
|
|
|
10
|
|
|
|
|
11
|
|
|
// Columns |
|
12
|
|
|
|
|
13
|
|
|
$.each(response.cols, function(key, column) { |
|
14
|
|
|
var dataTableColumnType; |
|
15
|
|
|
|
|
16
|
|
|
switch (column.type) { |
|
17
|
|
|
case 'date': |
|
18
|
|
|
dataTableColumnType = 'date'; |
|
19
|
|
|
break; |
|
20
|
|
|
case 'percent': |
|
21
|
|
|
case 'time': |
|
22
|
|
|
case 'integer': |
|
23
|
|
|
case 'currency': |
|
24
|
|
|
case 'float': |
|
25
|
|
|
dataTableColumnType = 'number'; |
|
26
|
|
|
break; |
|
27
|
|
|
|
|
28
|
|
|
default: |
|
29
|
|
|
dataTableColumnType = 'string'; |
|
30
|
|
|
} |
|
31
|
|
|
|
|
32
|
|
|
dataTable.addColumn({ |
|
33
|
|
|
type: dataTableColumnType, |
|
34
|
|
|
label: column.label, |
|
35
|
|
|
id: column.id, |
|
36
|
|
|
}); |
|
37
|
|
|
}); |
|
38
|
|
|
|
|
39
|
|
|
|
|
40
|
|
|
// Rows |
|
41
|
|
|
|
|
42
|
|
|
$.each(response.rows, $.proxy(function(keyRow, row) { |
|
43
|
|
|
|
|
44
|
|
|
var dataTableRow = []; |
|
45
|
|
|
|
|
46
|
|
|
$.each(response.cols, $.proxy(function(keyColumn, column) { |
|
47
|
|
|
switch (column.type) { |
|
48
|
|
|
case 'date': |
|
49
|
|
|
dataTableRow[keyColumn] = Analytics.Utils.formatByType(localeDefinition, column.type, row[keyColumn]); |
|
50
|
|
|
break; |
|
51
|
|
|
|
|
52
|
|
|
case 'float': |
|
53
|
|
|
dataTableRow[keyColumn] = +row[keyColumn]; |
|
54
|
|
|
break; |
|
55
|
|
|
|
|
56
|
|
|
case 'integer': |
|
57
|
|
|
case 'currency': |
|
58
|
|
|
case 'percent': |
|
59
|
|
|
case 'time': |
|
60
|
|
|
case 'continent': |
|
61
|
|
|
case 'subContinent': |
|
62
|
|
|
dataTableRow[keyColumn] = { |
|
63
|
|
|
v: Analytics.Utils.formatRawValueByType(localeDefinition, column.type, row[keyColumn]), |
|
64
|
|
|
f: Analytics.Utils.formatByType(localeDefinition, column.type, row[keyColumn]) |
|
65
|
|
|
}; |
|
66
|
|
|
break; |
|
67
|
|
|
|
|
68
|
|
|
default: |
|
69
|
|
|
dataTableRow[keyColumn] = row[keyColumn]; |
|
70
|
|
|
} |
|
71
|
|
|
}, this)); |
|
72
|
|
|
|
|
73
|
|
|
dataTable.addRow(dataTableRow); |
|
74
|
|
|
|
|
75
|
|
|
}, this)); |
|
76
|
|
|
|
|
77
|
|
|
return dataTable; |
|
78
|
|
|
}, |
|
79
|
|
|
|
|
80
|
|
|
formatRawValueByType: function(localeDefinition, type, value) { |
|
81
|
|
|
switch (type) { |
|
82
|
|
|
case 'integer': |
|
83
|
|
|
case 'currency': |
|
84
|
|
|
case 'percent': |
|
85
|
|
|
case 'time': |
|
86
|
|
|
case 'float': |
|
87
|
|
|
return +value; |
|
88
|
|
|
break; |
|
|
|
|
|
|
89
|
|
|
|
|
90
|
|
|
default: |
|
91
|
|
|
return value; |
|
92
|
|
|
} |
|
93
|
|
|
}, |
|
94
|
|
|
|
|
95
|
|
|
formatByType: function(localeDefinition, type, value) { |
|
96
|
|
|
switch (type) { |
|
97
|
|
|
case 'continent': |
|
98
|
|
|
return Analytics.Metadata.getContinentByCode(value); |
|
99
|
|
|
break; |
|
|
|
|
|
|
100
|
|
|
|
|
101
|
|
|
case 'subContinent': |
|
102
|
|
|
return Analytics.Metadata.getSubContinentByCode(value); |
|
103
|
|
|
break; |
|
|
|
|
|
|
104
|
|
|
|
|
105
|
|
|
case 'currency': |
|
106
|
|
|
return Analytics.Utils.formatCurrency(localeDefinition, +value); |
|
107
|
|
|
break; |
|
|
|
|
|
|
108
|
|
|
|
|
109
|
|
|
case 'float': |
|
110
|
|
|
return +value; |
|
111
|
|
|
break; |
|
|
|
|
|
|
112
|
|
|
|
|
113
|
|
|
case 'integer': |
|
114
|
|
|
return Analytics.Utils.formatInteger(localeDefinition, +value); |
|
115
|
|
|
break; |
|
|
|
|
|
|
116
|
|
|
|
|
117
|
|
|
case 'time': |
|
118
|
|
|
return Analytics.Utils.formatDuration(+value); |
|
119
|
|
|
break; |
|
|
|
|
|
|
120
|
|
|
|
|
121
|
|
|
case 'percent': |
|
122
|
|
|
return Analytics.Utils.formatPercent(localeDefinition, +value); |
|
123
|
|
|
break; |
|
|
|
|
|
|
124
|
|
|
|
|
125
|
|
|
case 'date': |
|
126
|
|
|
$dateString = value; |
|
|
|
|
|
|
127
|
|
|
|
|
128
|
|
|
if ($dateString.length == 8) { |
|
129
|
|
|
// 20150101 |
|
130
|
|
|
|
|
131
|
|
|
$year = eval($dateString.substr(0, 4)); |
|
|
|
|
|
|
132
|
|
|
$month = eval($dateString.substr(4, 2)) - 1; |
|
|
|
|
|
|
133
|
|
|
$day = eval($dateString.substr(6, 2)); |
|
|
|
|
|
|
134
|
|
|
|
|
135
|
|
|
$date = new Date($year, $month, $day); |
|
|
|
|
|
|
136
|
|
|
|
|
137
|
|
|
return $date; |
|
138
|
|
|
} else if ($dateString.length == 6) { |
|
139
|
|
|
// 201501 |
|
140
|
|
|
|
|
141
|
|
|
$year = eval($dateString.substr(0, 4)); |
|
|
|
|
|
|
142
|
|
|
$month = eval($dateString.substr(4, 2)) - 1; |
|
|
|
|
|
|
143
|
|
|
|
|
144
|
|
|
$date = new Date($year, $month, '01'); |
|
145
|
|
|
|
|
146
|
|
|
return $date; |
|
147
|
|
|
} |
|
148
|
|
|
break; |
|
|
|
|
|
|
149
|
|
|
|
|
150
|
|
|
default: |
|
151
|
|
|
return value; |
|
152
|
|
|
break; |
|
|
|
|
|
|
153
|
|
|
} |
|
154
|
|
|
}, |
|
155
|
|
|
|
|
156
|
|
|
formatCurrency: function(localeDefinition, value) { |
|
157
|
|
|
var d3Locale = this.getD3Locale(localeDefinition); |
|
158
|
|
|
var formatter = d3Locale.format(Craft.charts.BaseChart.defaults.formats.currencyFormat); |
|
|
|
|
|
|
159
|
|
|
|
|
160
|
|
|
return formatter(value); |
|
161
|
|
|
}, |
|
162
|
|
|
|
|
163
|
|
|
formatDuration: function(_seconds) { |
|
164
|
|
|
var sec_num = parseInt(_seconds, 10); // don't forget the second param |
|
165
|
|
|
var hours = Math.floor(sec_num / 3600); |
|
166
|
|
|
var minutes = Math.floor((sec_num - (hours * 3600)) / 60); |
|
167
|
|
|
var seconds = sec_num - (hours * 3600) - (minutes * 60); |
|
168
|
|
|
|
|
169
|
|
|
if (hours < 10) { |
|
170
|
|
|
hours = "0" + hours; |
|
171
|
|
|
} |
|
172
|
|
|
if (minutes < 10) { |
|
173
|
|
|
minutes = "0" + minutes; |
|
174
|
|
|
} |
|
175
|
|
|
if (seconds < 10) { |
|
176
|
|
|
seconds = "0" + seconds; |
|
177
|
|
|
} |
|
178
|
|
|
return hours + ':' + minutes + ':' + seconds; |
|
179
|
|
|
}, |
|
180
|
|
|
|
|
181
|
|
|
formatInteger: function(localeDefinition, value) { |
|
182
|
|
|
return this.getD3Locale(localeDefinition).format(",")(value); |
|
183
|
|
|
}, |
|
184
|
|
|
|
|
185
|
|
|
formatPercent: function(localeDefinition, value) { |
|
186
|
|
|
return this.getD3Locale(localeDefinition).format(Craft.charts.BaseChart.defaults.formats.percentFormat)(value / 100); |
|
|
|
|
|
|
187
|
|
|
}, |
|
188
|
|
|
|
|
189
|
|
|
getD3Locale: function(localeDefinition) { |
|
190
|
|
|
return d3.formatLocale(localeDefinition); |
|
|
|
|
|
|
191
|
|
|
}, |
|
192
|
|
|
}; |
|
193
|
|
|
|